# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月13日
"""
import pandas as pd

path = '../数据文件/课件026/分组聚合2.xlsx'
data = pd.read_excel(path)

dic = {'1月': 'count', '2月': sum, '3月': max, '4月': 'mean'}

data2 = data.groupby('店号').agg(dic)


print(data2)